Works, Microsoft - sorting columns - first select and Copy the range of columns you want to sort. Paste this selection into a new spreadsheet using Paste With Options instead of the standard Paste command. Choose both Formulas and Values and Transpose and click ok. Now reselect the range (that is now in a row), use the sort command from the edit menu. When the sort is completed, cut the data and then paste it back onto the original range, using the Paste with Options command with both Formulas and Transpose options selected.